package com.example.mysql.学习笔记.MYSQL8.窗口函数.用例二;

public class 创表 {
}
/**
 * 分类讲解
 *
 * 创建表：
 *
 * ```mysql
 * CREATE TABLE goods(
 * id INT PRIMARY KEY AUTO_INCREMENT,
 * category_id INT,
 * category VARCHAR(15),
 * NAME VARCHAR(30),
 * price DECIMAL(10,2),
 * stock INT,
 * upper_time DATETIME
 *
 * );
 * ```
 *
 * 添加数据：
 *
 * INSERT INTO goods(category_id,category,NAME,price,stock,upper_time)
 * VALUES
 * (1, '女装/女士精品', 'T恤', 39.90, 1000, '2020-11-10 00:00:00'),
 * (1, '女装/女士精品', '连衣裙', 79.90, 2500, '2020-11-10 00:00:00'),
 * (1, '女装/女士精品', '卫衣', 89.90, 1500, '2020-11-10 00:00:00'),
 * (1, '女装/女士精品', '牛仔裤', 89.90, 3500, '2020-11-10 00:00:00'),
 * (1, '女装/女士精品', '百褶裙', 29.90, 500, '2020-11-10 00:00:00'),
 * (1, '女装/女士精品', '呢绒外套', 399.90, 1200, '2020-11-10 00:00:00'),
 * (2, '户外运动', '自行车', 399.90, 1000, '2020-11-10 00:00:00'),
 * (2, '户外运动', '山地自行车', 1399.90, 2500, '2020-11-10 00:00:00'),
 * (2, '户外运动', '登山杖', 59.90, 1500, '2020-11-10 00:00:00'),
 * (2, '户外运动', '骑行装备', 399.90, 3500, '2020-11-10 00:00:00'),
 * (2, '户外运动', '运动外套', 799.90, 500, '2020-11-10 00:00:00'),
 * (2, '户外运动', '滑板', 499.90, 1200, '2020-11-10 00:00:00');
 * ```
 *
 */
